<?php
/*
	[UCenter Home] (C) 2007-2008 Comsenz Inc.
	$Id: profile.php 2009-11-3 $ 
*/

if(!defined('IN_UCHOME')) {
	exit('Access Denied');
}

include_once(S_ROOT.'./source/function_cp.php');
include_once(S_ROOT.'./site/libs/func_util.php');
include_once(S_ROOT.'./site/libs/func_model.php');

$sql = "SELECT DISTINCT p.*, sp.*, pf.* FROM ".tname('mtag')." p 
         LEFT JOIN ".tname('spot')." sp ON p.tagid=sp.tag1 OR p.tagid=sp.tag2 
         LEFT JOIN ".tname('profield')." pf ON p.fieldid=pf.fieldid
         WHERE p.tagid<>$profid AND (sp.tag1=$profid OR sp.tag2=$profid)";
		
 $query = $_SGLOBAL['db']->query($sql);
 while ($value = $_SGLOBAL['db']->fetch_array($query)) {
		$spotlist[] = $value;
 }


include template('site/tpl/hotspot');
exit;
?>